MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

43 rows where Artist Alpha Sort = 17695

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
207330 1997.454 0 1 334682 Drawings and Prints 11 Drawing 23 A Group of Figures Surrounding Two Bird-coops           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695   1722 1780 1697–1768 1697 1768 Pen and brown ink over lead or graphite underdrawing 29416 8 3/16 x 11 9/16 in. (20.8 x 29.4 cm) Anonymous Gift, 1997                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
208036 26.57.59(10a) 0 0 335394 Drawings and Prints 11 Print 731 Capriccio with a Domed Church         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 5 1/2 x 8 in. (14.0 x 20.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208037 26.57.59(10d) 0 0 335395 Drawings and Prints 11 Print 731 The Canal and Fortifications at Padua with the Porta Pontecorvo and Santa Giustina         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 5 1/2 x 8 in. (14 x 20.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208038 26.57.59(10f) 0 0 335396 Drawings and Prints 11 Print 731 Paduan Capriccio with a Gateway in the Style of the Porta Portello and a Bridge         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching, ii 29857 5 1/2 x 7 7/8 in. (14 x 20 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208039 26.57.59(10c) 0 0 335397 Drawings and Prints 11 Print 731 A View of Padua with a Gateway and a Domed Church         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 5 1/2 x 8 in. (14.0 x 20.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208040 26.57.59(10e) 0 0 335398 Drawings and Prints 11 Print 731 Outskirts of Padua with a Gate         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 5 1/2 x 8 in. (14.0 x 20.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208041 26.57.59(10h) 0 0 335399 Drawings and Prints 11 Print 731 A View of Padua from the Fortifications         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 5 11/16 x 7 7/8 in. (14.5 x 20.0 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208042 26.57.59(10b) 0 0 335400 Drawings and Prints 11 Print 731 Capriccio with the Ruins of a Roman Temple on the Shores of a Lagoon         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 7 5/16 x 9 15/16 in. (18.5 x 25.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208043 26.57.59(10g) 0 0 335401 Drawings and Prints 11 Print 731 Capriccio: Landscape with Ruins of an Arcaded Building         Eight Italian views, printed together on a single sheet 99 Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1741–42 1741 1742 Etching 26137 7 5/16 x 9 15/16 in. (18.6 x 25.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208398 26.57.59 0 0 335761 Drawings and Prints 11 Book 97 Raccolta di Vedute della Citta di Dresda           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1745–50 1740 1755 Etching 26137 27 1/2 x 20 3/16 in. (69.8 x 51.3 cm) Harris Brisbane Dick Fund, 1926                       Books 442   Metropolitan Museum of Art, New York, NY 1
208577 26.57.59(1) 0 0 335949 Drawings and Prints 11 Print 731 The Old Fortifications, Dresden           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1750 1750 1750 Etching i/ii 30200 21 9/16 x 33 1/16 in. (54.7 x 84 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208578 26.57.59(2) 0 0 335950 Drawings and Prints 11 Print 731 The New City Market-Place, Dresden           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1750 1750 1750 Etching 26137 21 1/4 x 33 11/16 in. (54 x 85.6 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208579 26.57.59(3) 0 0 335951 Drawings and Prints 11 Print 731 The Newmarkt, Dresden, from the Judenhof           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1749 1749 1749 Etching i/ii 30200 21 5/8 x 33 1/16 in. (55 x 83.9 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208580 26.57.59(4) 0 0 335952 Drawings and Prints 11 Print 731 The Neumarkt, Dresden, from Moritzstrasse           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1750 1750 1750 Etching i/ii 30200 21 5/8 x 33 1/4 in. (54.9 x 84.4 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208581 26.57.59(5) 0 0 335953 Drawings and Prints 11 Print 731 Dresden from the right bank of the Elbe, below the Augustusbrucke           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1748 1748 1748 Etching ii/iv 30201 21 1/4 x 32 13/16 in. (53.9 x 83.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208582 26.57.59(6) 0 0 335954 Drawings and Prints 11 Print 731 Dresden from the Right Bank of the Elbe, above the Augustusbrucke           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1747 1747 1747 Etching ii/iii 30202 21 7/16 x 33 3/8 in. (54.4 x 84.8 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208583 26.57.59(7) 0 0 335955 Drawings and Prints 11 Print 731 Dresden from the Left (Old City) Bank of the Elbe, above the Bridge           Artist 2 Etched by Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1748 1748 1748 Etching ii/iii 30202 21 3/8 x 32 7/8 in. (54.3 x 83.5 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208584 26.57.59(8) 0 0 335956 Drawings and Prints 11 Print 731 Dresden from the Left Bank of the Elbe, below the Fortifications           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1747 1747 1747 Etching iii/v 30203 17 11/16 x 25 9/16 in. (45 x 65 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208585 26.57.59(9) 0 0 335957 Drawings and Prints 11 Print 731 Paysage, d' apres Van der Hayden           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1745 1740 1750 Etching ii/ii 30204 plate: 21 3/4 x 25 13/16 in. (55.2 x 65.5 cm) sheet: 26 9/16 x 36 5/8 in. (67.4 x 93 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
208760 1998.267 0 0 336135 Drawings and Prints 11 Print 731 The Ruins of the Old Kreuzkirche, Dresden           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1765 1765 1765 Etching 26137 Plate: 21 × 25 3/8 in. (53.3 × 64.5 cm) Sheet: 25 1/16 × 29 7/16 in. (63.7 × 74.7 cm) Purchase, 1998                       Prints 13   Metropolitan Museum of Art, New York, NY 1
209265 53.637.2 0 0 336646 Drawings and Prints 11 Print 731 View of Pirna, with the Elbe at the right and the castle of Sonnenstein to the left           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1760–65 1755 1770 Etching 26137 Plate: 16 9/16 × 24 15/16 in. (42 × 63.4 cm) Sheet: 21 9/16 × 27 13/16 in. (54.8 × 70.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
210803 1972.118.242 0 1 338189 Drawings and Prints 11 Drawing 23 Padua from the East, with San Francesco and the Salone           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1721–80 1721 1780 Pen and brown ink, over constructed outline drawing in graphite or lead 31420 7 1/2 x 10 11/16in. (19.1 x 27.1cm) Bequest of Walter C. Baker, 1971                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
210804 1975.131.7 0 1 338190 Drawings and Prints 11 Drawing 23 San Simeone Piccolo, Venice, Seen from the Grand Canal           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1721–80 1721 1780 Pen and brown ink, over constructed outline drawing in graphite or lead and black chalk 31421 10 1/2 x 14 3/4in. (26.7 x 37.5cm) Bequest of Harry G. Sperling, 1971                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
236670 53.601.329 0 0 364618 Drawings and Prints 11 Print 731 View of the Town of Pirna: Before the Oberthor Gate           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1753–63 1748 1768 Etching; first state of two 29408 Image: 13 3/4 × 20 11/16 in. (35 × 52.5 cm) Sheet: 16 1/8 × 20 7/8 in. (41 × 53.1 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
242933 33.22.1 0 0 371106 Drawings and Prints 11 Print 731 View of the old market place in Dresden, with the Church of the Holy Cross in the background           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1752 1752 1752 Etching 26137 Plate: 21 1/4 × 32 11/16 in. (54 × 83 cm) Sheet: 25 3/8 × 35 1/8 in. (64.5 × 89.2 cm) Harris Brisbane Dick Fund, 1933                       Prints 13   Metropolitan Museum of Art, New York, NY 1
242976 33.22.2 0 0 371151 Drawings and Prints 11 Print 731 View of the marketplace, Dresden           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1752 1752 1752 Etching 26137 Plate: 21 × 32 7/8 in. (53.4 × 83.5 cm) Sheet: 23 13/16 × 36 7/16 in. (60.5 × 92.5 cm) Harris Brisbane Dick Fund, 1933                       Prints 13   Metropolitan Museum of Art, New York, NY 1
242993 53.631.1 0 0 371168 Drawings and Prints 11 Print 731 Sonnenstein Castle and Pirna from a Hill on the Konigstein Road           Artist 2 Etched by Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1756–ca. 1766 1751 1771 Etching, ii 29857   The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
305756 1991.306 0 1 435646 European Paintings 15 Painting 69 Pirna: The Obertor from the South           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1760s 1760 1769 Oil on canvas 953 18 1/4 x 30 3/4 in. (46.4 x 78.1 cm) Wrightsman Fund, 1991                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
305757 39.142 0 1 435647 European Paintings 15 Painting 69 Vaprio d'Adda           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 1744 1744 1744 Oil on canvas 953 25 1/4 x 39 1/4 in. (64.1 x 99.7 cm) Purchase, Joseph Pulitzer Bequest, 1939                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
321625 1975.1.303 0 1 459595 Robert Lehman Collection 16 Drawing 23 The Grand Canal from Ca'Moro-Lin and Ca'Foscari to the Carità           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1736–37 1733 1740 Pen and brown ink, gray wash 29693 9 15/16 x 16 15/16 in. (25.3 x 43.1 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321626 1975.1.305 0 1 459596 Robert Lehman Collection 16 Drawing 23 The Grand Canal from the Carità to the Dogana da Mar           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1736–37 1733 1740 Pen and brown ink, gray wash 29693 9 15/16 x 17 1/16 in. (25.3 x 43.3 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321627 1975.1.304 0 1 459597 Robert Lehman Collection 16 Drawing 23 The Entrance to the Grand Canal, with the Dogana da Mar and Santa Maria della Salute on the Left           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1736–37 1733 1740 Pen and brown ink, gray wash 29693 10 x 16 15/16 in. (25.4 x 43 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321628 1975.1.306 0 1 459598 Robert Lehman Collection 16 Drawing 23 The Grand Canal with the Rialto Bridge, from the North           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1736–37 1733 1740 Pen and brown ink, gray wash 29693 10 1/16 x 16 15/16 in. (25.5 x 43 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321629 1975.1.307 0 1 459599 Robert Lehman Collection 16 Drawing 23 The Grand Canal, with the Fabbriche Nuove on the Left and Campanile of Santi Apostoli on the Right           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1736–37 1733 1740 Pen and brown ink, gray wash 29693 10 1/16 x 16 15/16 in. (25.5 x 43 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321630 1975.1.301 0 1 459600 Robert Lehman Collection 16 Drawing 23 View of Dolo           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and brown ink, gray wash 29693 11 5/8 x 16 1/16 in. (29.6 x 40.8 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321631 1975.1.302 0 1 459601 Robert Lehman Collection 16 Drawing 23 A Village on the Brenta           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and brown ink, gray wash 29693 11 9/16 x 15 7/8 in. (29.3 x 40.3 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321632 1975.1.308 0 1 459602 Robert Lehman Collection 16 Drawing 23 The Tower of Marghera           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and brownish black ink, gray wash, over graphite 48068 11 9/16 x 15 7/8 in. (29.4 x 40.4 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321633 1975.1.309 0 1 459603 Robert Lehman Collection 16 Drawing 23 View of Mestre           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and brownish black ink, gray wash, over traces of graphite 48069 11 5/8 x 16 1/16 in. (29.5 x 40.8 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321634 1975.1.311 0 1 459604 Robert Lehman Collection 16 Drawing 23 Santa Giustina and the Prato della Valle at Padua           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and brown ink, gray wash 29693 12 5/8 x 16 3/4 in. (32 x 42.6 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321635 1975.1.310 0 1 459605 Robert Lehman Collection 16 Drawing 23 The Prato della Valle at Padua           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and brown ink, gray wash 29693 12 5/8 x 16 11/16 in. (32 x 42.4 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321636 1975.1.299 0 1 459606 Robert Lehman Collection 16 Drawing 23 Imaginary View of Padua           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1740–41 1737 1744 Pen and black ink, gray wash 30404 12 9/16 x 16 3/4 in. (31.9 x 42.6 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321637 1975.1.300 0 1 459607 Robert Lehman Collection 16 Drawing 23 A Venetian Villa           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695 Italian 6 1722 1780 ca. 1741–80 1738 1783 Pen and brown ink, gray wash 29693 7 1/2 x 10 7/8 in. (19 x 27.7 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
452429 53.637.1 0 0 760235 Drawings and Prints 11 Print 731 View with the fortress of Sonnenstein in the background and the Elbe river on the left           Artist 2   Bernardo Bellotto Italian, Venice 1722–1780 Warsaw   Bellotto, Bernardo 17695   1722 1780 ca. 1760–65 1755 1770 Etching; second state of two 29783 Plate: 16 9/16 × 21 7/16 in. (42 × 54.4 cm) Sheet: 20 in. × 26 3/4 in. (50.8 × 68 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 130.167ms · Data license: CC0 · Data source: metmuseum/openaccess